/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.tlf.dyjc5.servlet.system;

import com.tlf.dyjc5.service.DeviceService;
import com.tlf.dyjc5.service.PointService;
import java.io.IOException;
import java.io.PrintWriter;

import java.sql.Timestamp;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.dusin.web.util.CommonWebUtil;
import org.dusin.web.util.JsonUtil;
import org.springframework.context.ApplicationContext;
import org.springframework.dao.DuplicateKeyException;
import org.springframework.web.context.support.WebApplicationContextUtils;

/**
 *
 * @author Administrator
 */
public class PointSave extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code>
     * methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            /* TODO output your page here. You may use following sample code. */
            ApplicationContext context = WebApplicationContextUtils.getWebApplicationContext(getServletContext());
            PointService pointService = (PointService) context.getBean("pointService");
            DeviceService deviceService = (DeviceService) context.getBean("deviceService");
            String msg = "数据库操作失败";
            String command = request.getParameter("cmd");
            boolean result = false;
            String orgCode = (String) request.getSession().getAttribute("currentOrgCode");
            if ("create".equals(command)) {

                String code = request.getParameter("code");
                String name = request.getParameter("name");
                long pointTypeId = Long.parseLong(request.getParameter("pointTypeId"));
                long pointType2Id = CommonWebUtil.getLongParameter(request.getParameter("pointType2Id"), 0);
                long voltageLevelId = Long.parseLong(request.getParameter("voltageLevelId"));
                //long deptId = CommonWebUtil.getLongParameter(request.getParameter("deptId"), 0);
                double lowerLimit = Double.parseDouble(request.getParameter("lowerLimit"));
                double upperLimit = Double.parseDouble(request.getParameter("upperLimit"));
                String pointArea = request.getParameter("pointArea");
                String pointPosition = request.getParameter("pointPosition");
                String userName = request.getParameter("userName");
                String publicName = request.getParameter("publicName");
                String effectTimeStr = request.getParameter("effectTime");
                
                String note = request.getParameter("note");
                long stationVoltageLevelId = CommonWebUtil.getLongParameter(request.getParameter("stationVoltageLevelId"), 0);
                String stationName = request.getParameter("stationName");
                String installTimeStr = request.getParameter("installTime");
                
                result = pointService.trAdd(code, name, pointTypeId, pointType2Id, voltageLevelId, lowerLimit, upperLimit, effectTimeStr, note, orgCode, userName, publicName, pointArea, pointPosition, stationVoltageLevelId, stationName, installTimeStr);
            } else if ("update".equals(command)) {
                String code = request.getParameter("code");
                String name = request.getParameter("name");
                long pointTypeId = Long.parseLong(request.getParameter("pointTypeId"));
                long pointType2Id = CommonWebUtil.getLongParameter(request.getParameter("pointType2Id"), 0);
                long voltageLevelId = Long.parseLong(request.getParameter("voltageLevelId"));
                double lowerLimit = Double.parseDouble(request.getParameter("lowerLimit"));
                double upperLimit = Double.parseDouble(request.getParameter("upperLimit"));
                String pointArea = request.getParameter("pointArea");
                String pointPosition = request.getParameter("pointPosition");
                String userName = request.getParameter("userName");
                String publicName = request.getParameter("publicName");
                String effectTimeStr = request.getParameter("effectTime");
                Timestamp effectTime = CommonWebUtil.getTimestampParamter(effectTimeStr);
                String note = request.getParameter("note");
                long id = Long.parseLong(request.getParameter("id"));
                long stationVoltageLevelId = CommonWebUtil.getLongParameter(request.getParameter("stationVoltageLevelId"), 0);
                String stationName = request.getParameter("stationName");
                String installTimeStr = request.getParameter("installTime");
                Timestamp installTime = CommonWebUtil.getTimestampParamter(installTimeStr);
                result = pointService.update(id, code, name, pointTypeId, pointType2Id, voltageLevelId, lowerLimit, upperLimit, effectTime, note, userName, publicName, pointArea, pointPosition, stationVoltageLevelId, stationName, installTime);
            }else if("batch".equals(command)){
                Enumeration<String> names = request.getParameterNames();
                Map<String,String> valueMap = new HashMap<String,String>();
                String ids = request.getParameter("pointIds");
                String condition = "where id in ("+ids+")";
                while(names.hasMoreElements()){
                    String name = names.nextElement();
                    if(name.endsWith("Checked")){
                        String paraNameOption = request.getParameter(name);
                        String paraName = name.substring(0, name.length()-"Checked".length());
                        String paraValue = request.getParameter(paraName);
                        if(paraValue==null)
                            paraValue="";
                        valueMap.put(paraName, paraValue);
                    }
                }
                if(valueMap.isEmpty()){
                    msg = "没有选择修改项";
                }else{
                    result  = pointService.batchUpdate(valueMap,condition);
                }
            } else if ("changeOrg".equals(command)) {
                String ids = request.getParameter("pointIds");
                String deviceIds = request.getParameter("deviceIds");
                String newOrgCode = request.getParameter("orgCode");
                result = pointService.changeOrg(newOrgCode, ids);
            } else if ("choose".equals(command)) {
                long pointId = Long.parseLong(request.getParameter("pointId"));
                long deviceId = Long.parseLong(request.getParameter("deviceId"));
                result = pointService.updateBinding(pointId, deviceId);
            } else if ("start".equals(command)) {
                String ids = request.getParameter("pointIds");
                String deviceIds = request.getParameter("deviceIds");
                String effectTimeStr = request.getParameter("effectTime");
                Timestamp effectTime = CommonWebUtil.getTimestampParamter(effectTimeStr);
                result = pointService.trStart(ids, deviceIds, effectTime);
            } else if ("stop".equals(command)) {
                String ids = request.getParameter("pointIds");
                String deviceIds = request.getParameter("deviceIds");
                String stopTimeStr = request.getParameter("stopTime");
                Timestamp stopTime = CommonWebUtil.getTimestampParamter(stopTimeStr);
                String reason = request.getParameter("stopReason");
                result = pointService.trStop(ids, deviceIds, stopTime, reason);
            } else if ("report".equals(command)) {
                String ids = request.getParameter("pointIds");
                int reportStatusId = Integer.parseInt(request.getParameter("reportStatusId"));
                result = pointService.trReport(ids, reportStatusId);
            } else if ("upload".equals(command)) {
                String ids = request.getParameter("pointIds");
                int reportStatusId = Integer.parseInt(request.getParameter("reportStatusId"));
                int type = Integer.parseInt(request.getParameter("type"));
                result = pointService.trUpdateStatus(ids, reportStatusId,type);
            } else if ("allocate".equals(command)) {
                String ids = request.getParameter("pointIds");
                long userId = Long.parseLong(request.getParameter("userId"));
                result = pointService.updateUser(ids, userId);
            } else if ("frompoint".equals(command)) {
                String ids = request.getParameter("pointIds");
                long frompointId = Long.parseLong(request.getParameter("frompointId"));
                result = pointService.updateFromPoint(ids, frompointId);
            } else if ("createDevice".equals(command)) {

                String deviceNo = request.getParameter("deviceNo");
                String installSite = request.getParameter("installSite");
                String mobileNo = request.getParameter("mobileNo");
                String terminalNo = request.getParameter("terminalNo");
                String channel = request.getParameter("channel");

                long modelId = Long.parseLong(request.getParameter("modelId"));
                int port = Integer.valueOf(request.getParameter("port"));

                String note = request.getParameter("note");
                String uniqueCode = request.getParameter("uniqueCode");
                String adminAreaCode = request.getParameter("adminAreaCode");
                String ip = request.getParameter("ip");
                int zbm = CommonWebUtil.getIntParameter(request.getParameter("zbm"), 0);
                String runTimeStr = request.getParameter("runTime");
                Timestamp runTime = Timestamp.valueOf(runTimeStr);

                String produceTimeStr = request.getParameter("produceTime");
                Timestamp produceTime;
                produceTime = CommonWebUtil.getTimestampParamter(produceTimeStr);

                String checkTimeStr = request.getParameter("checkTime");
                Timestamp checkTime;
                checkTime = CommonWebUtil.getTimestampParamter(checkTimeStr);

                String expireTimeStr = request.getParameter("expireTime");
                Timestamp expireTime;
                expireTime = CommonWebUtil.getTimestampParamter(expireTimeStr);

                long id = Long.parseLong(request.getParameter("pointId"));
                result = pointService.trAddNewDevice(id, deviceNo, modelId, installSite, mobileNo, terminalNo, channel,
                        uniqueCode, adminAreaCode, ip, port, runTime, produceTime, checkTime, expireTime, note,
                        orgCode, zbm);

            } else if ("updateDevice".equals(command)) {
                String deviceNo = request.getParameter("deviceNo");
                String installSite = request.getParameter("installSite");
                String mobileNo = request.getParameter("mobileNo");
                String terminalNo = request.getParameter("terminalNo");
                String channel = request.getParameter("channel");
                long modelId = Long.parseLong(request.getParameter("modelId"));
                int port = Integer.valueOf(request.getParameter("port"));

                String note = request.getParameter("note");
                String uniqueCode = request.getParameter("uniqueCode");
                String adminAreaCode = request.getParameter("adminAreaCode");
                String ip = request.getParameter("ip");
                //int zbm = Integer.valueOf(request.getParameter("zbm"));
                int zbm = CommonWebUtil.getIntParameter(request.getParameter("zbm"), 0);
                String runTimeStr = request.getParameter("runTime");
                Timestamp runTime = Timestamp.valueOf(runTimeStr);

                String produceTimeStr = request.getParameter("produceTime");
                Timestamp produceTime;
                produceTime = CommonWebUtil.getTimestampParamter(produceTimeStr);

                String checkTimeStr = request.getParameter("checkTime");
                Timestamp checkTime;
                checkTime = CommonWebUtil.getTimestampParamter(checkTimeStr);

                String expireTimeStr = request.getParameter("expireTime");
                Timestamp expireTime;
                expireTime = CommonWebUtil.getTimestampParamter(expireTimeStr);
                String protocolCode = request.getParameter("protocolCode");

                long id = Long.parseLong(request.getParameter("id"));
                result = deviceService.update(id, deviceNo, modelId, installSite, mobileNo, terminalNo, channel,
                        uniqueCode, adminAreaCode, ip, port, runTime, produceTime, checkTime, expireTime, note,
                        orgCode, zbm, protocolCode);
            } else if ("restore".equals(command)) {
                String ids = request.getParameter("ids");
                result = pointService.trRestoreById(ids);
            }
            if (result) {
                out.println(JsonUtil.createSuccessJsonResponse(msg));
            } else {
                out.print(JsonUtil.createFailureJsonResponse(msg));
            }

        } catch (DuplicateKeyException e) {
            String msg = e.getMessage();
            if (msg.indexOf("deviceNo") != -1) {
                out.print(JsonUtil.createFailureJsonResponse("设备编号不能和现有数据库中的记录重复"));
            } else if (msg.indexOf("point_name") != -1) {
                out.print(JsonUtil.createFailureJsonResponse("监测点名称不能和现有数据库中的记录重复"));
            }
            e.printStackTrace();
        } catch (Exception e) {
            out.print(JsonUtil.createFailureJsonResponse("不明操作错误"));
            e.printStackTrace();
        } finally {
            out.close();
        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
